UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'H7FyN+TU1YAHyAFGYORsYhE8mq48r6Eie75ys4twknA='
WHERE
key_id = 'd67ff583acbce238136cd28ec73578169d48c748b6e8ebe468325db451387d98'
AND (
token = 'H7FyN+TU1YAHyAFGYORsYhE8mq48r6Eie75ys4twknA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)