UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zOQ4EXz/SHwErzWMkEmINSAZ6zMmCCZIsCPbMxNK2UE='
WHERE
key_id = 'e55c269e409ab84c2d29197add1bc40eae028135bafe48854386507ece5d3aa4'
AND (
token = 'zOQ4EXz/SHwErzWMkEmINSAZ6zMmCCZIsCPbMxNK2UE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)