UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7Quqn5jmZn5AipXT7cE04PkHvfSN7SY4e5rJvtxT3bw='
WHERE
key_id = '92d20bdb27872c0c56bebabdb9726ab74e41cb96fec87a854244480dc1b23082'
AND (
token = '7Quqn5jmZn5AipXT7cE04PkHvfSN7SY4e5rJvtxT3bw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)