UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XEwtdgW8YX/OSwLtWOeCYAWzPHxEKWzWOKo9vUDi7qU='
WHERE
key_id = '0699bfc7a506435eac595d1f7e34257fdc010121b1bae3b3c8567ba0c3fbf765'
AND (
token = 'XEwtdgW8YX/OSwLtWOeCYAWzPHxEKWzWOKo9vUDi7qU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)