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