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