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