UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'H3AFb8ACDhKU/pSyemmNgDOZVTY/h7M2VsRLffmuxKU='
WHERE
key_id = '6dcd1678c54a5d32d62772be52a89a68e90cde2461f6efc0b9f2599855f1fc5a'
AND (
token = 'H3AFb8ACDhKU/pSyemmNgDOZVTY/h7M2VsRLffmuxKU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)