UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '47q4ZL3i5fAmTg/oj4y7NT1jNNqnEVKrw2v5NjB957U=' 
WHERE 
  key_id = '388f36b74a24f6fb1e9f794d81b59683ce689a2bb8941d9d38d4a917a29cb623' 
  AND (
    token = '47q4ZL3i5fAmTg/oj4y7NT1jNNqnEVKrw2v5NjB957U=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00024