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