UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'op7L3KrTTfn2JRSAwyrjtgpZLwVhZcB42WXmmIbzE74='
WHERE
key_id = '4ac275c7fc76bd28bf86d65382a8605524f635415ffdbe1adc94fbf33b552f8a'
AND (
token = 'op7L3KrTTfn2JRSAwyrjtgpZLwVhZcB42WXmmIbzE74='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)