UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Q4nYGMqNH3ofC0s4LJxUg9tWUPl2hS1GAQP2HdhmKig=' 
WHERE 
  key_id = '9c55c6cf4f6bcef1a2d92e6d59e28c602e72dd9693cacc837dc9625415453f17' 
  AND (
    token = 'Q4nYGMqNH3ofC0s4LJxUg9tWUPl2hS1GAQP2HdhmKig=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00018