UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N2LFKdhxLezjNwbBjG5rhj02VgsXx4E6WUwl4puR4a8='
WHERE
key_id = '77f4a6eb5448a68f8151a3794e808ec8d2c5d4fcbfd9154ed8955f1d3d46d92d'
AND (
token = 'N2LFKdhxLezjNwbBjG5rhj02VgsXx4E6WUwl4puR4a8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)