UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'APCnFcp8L/Novoc0/5Gn6m+CCfKDT6us+5R8+f0Tvws='
WHERE
key_id = '0e20d367bf635dc4061fbfd2e7f4310a1ead28e534654e57c14803ce929ef286'
AND (
token = 'APCnFcp8L/Novoc0/5Gn6m+CCfKDT6us+5R8+f0Tvws='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)