UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XVmrODLOf6rUnb1y3P4gDzJ3GDvsfvSANf+cExKPLKM='
WHERE
key_id = 'f6e65d3cc6f384d54ebfe307861c6eee870578207780c71dc28c477a18c7f1c9'
AND (
token = 'XVmrODLOf6rUnb1y3P4gDzJ3GDvsfvSANf+cExKPLKM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)