UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NlRktWe+NTJ+aMKKy7MTdWOfFZFzXBwBxLhlp3zJSrg='
WHERE
key_id = 'b20926a3940fe7dec193d52da2a5f0cfb270e9a232465be8048de9083ff2b204'
AND (
token = 'NlRktWe+NTJ+aMKKy7MTdWOfFZFzXBwBxLhlp3zJSrg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)