UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zuZWPbsBKxJArGp2l608IGMvuyMpNR5/pguHEe4Rnw4='
WHERE
key_id = 'b6b2cd56ec23f931cff1b74f5f97ffec8b8a06835e73559534f7dbb72f82b057'
AND (
token = 'zuZWPbsBKxJArGp2l608IGMvuyMpNR5/pguHEe4Rnw4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)