UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'soMpsrjlahGTAeIDYV62qj5em3clo35n+HGK1q5DoAk='
WHERE
key_id = '7a3bf668b89f2a899a4bca17ce78f16206f5fa8f61b5ec0b5a55f11175efe5da'
AND (
token = 'soMpsrjlahGTAeIDYV62qj5em3clo35n+HGK1q5DoAk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)