UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4YivLdxTA9WUKpoybQRxxlgXuUf1VJJqprmy4xrN7gM='
WHERE
key_id = '7be805f8b1927eca871631fd6ee22ff1a19852a3208ad037a8292606ab1687ee'
AND (
token = '4YivLdxTA9WUKpoybQRxxlgXuUf1VJJqprmy4xrN7gM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)