UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'L7FZsDHnZF3zlXH2jydtsr2LMAZ4DPiWkp0n2Gj021U='
WHERE
key_id = 'bc52d8664bb531b9ed973d5166f26044c25d8f347d61bb1cb647d057bc8fa423'
AND (
token = 'L7FZsDHnZF3zlXH2jydtsr2LMAZ4DPiWkp0n2Gj021U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)