UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'viNoJo28nFes8tyzNSOQGsxHR2nVYBv2YDbKD1Lprpo='
WHERE
key_id = 'ca6b52ca086ca49ac3592e61f01742debacd30be815ed658d3d8b204ec8dddcf'
AND (
token = 'viNoJo28nFes8tyzNSOQGsxHR2nVYBv2YDbKD1Lprpo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)