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