UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AfVz5U6ecVAFLW7MU/7c1Sp5SBztLfQ7akEdxQq2J7k='
WHERE
key_id = 'a8d639471f03a7768354467bc76690c924c7f854fd4e13275a1a36f9c19b29ba'
AND (
token = 'AfVz5U6ecVAFLW7MU/7c1Sp5SBztLfQ7akEdxQq2J7k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)