UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'hiYBTG8LD7ygEz+kj/9ioeaHKDy6xe2ku/enx9wlhFA=' 
WHERE 
  key_id = '71f032311b0c38a4dd599f82208729214bb68e9f28aaf0dd4e911cf4995c1afa' 
  AND (
    token = 'hiYBTG8LD7ygEz+kj/9ioeaHKDy6xe2ku/enx9wlhFA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00041