UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zIwfI379/pU198X3Uwz1kFWzKgkhtHlC/5gRiXaQNnk='
WHERE
key_id = '7e856e9e3d3d25ce06f55a48ed0196218dc3799676a7ebc1d57c62d095fc498b'
AND (
token = 'zIwfI379/pU198X3Uwz1kFWzKgkhtHlC/5gRiXaQNnk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)