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