UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0aOPnvYOFeutyIoN7BbaOtdXtWB8Bgvsnl7B3NhOxrs='
WHERE
key_id = '16cbcca56e1fe714de866b01a7043cd0672b2cbb7b14aa9e0cca106b4be28f66'
AND (
token = '0aOPnvYOFeutyIoN7BbaOtdXtWB8Bgvsnl7B3NhOxrs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)