UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BSLDmrziOs1vhLLHF0PVWwNqmXwWpjvg0Ke+716XrdQ='
WHERE
key_id = 'a0242b5f6d78c153f002a7e9d62fa830f50e58f1f62189d9258b6f36d18069dc'
AND (
token = 'BSLDmrziOs1vhLLHF0PVWwNqmXwWpjvg0Ke+716XrdQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)