UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Ob9MwwjiMlkc0G2IontmHyeFAle/QfF7P0tOJzA8bog='
WHERE
key_id = '17b1e740f8bc26aeef77ad16c7f20ca95d270395d8a4bf755b0cc8f996fd6d27'
AND (
token = 'Ob9MwwjiMlkc0G2IontmHyeFAle/QfF7P0tOJzA8bog='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)