UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UJuz+pmeVR5yMA1kUds0cDI8demOfSFI5xG6rJBpGj0='
WHERE
key_id = 'b379583d7e9a51fbb7b44a387803e001e664c0d710f5979b830ab2a76a66c0af'
AND (
token = 'UJuz+pmeVR5yMA1kUds0cDI8demOfSFI5xG6rJBpGj0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)