UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'hsQB0RHUIm3MU81C2B9sHb1B34Cj7I9KcN1e7aHVZsI=' 
WHERE 
  key_id = '65a71272c3376ca78e70ca8b56ea114f939b20a9802b9da039ab4bf3c6452498' 
  AND (
    token = 'hsQB0RHUIm3MU81C2B9sHb1B34Cj7I9KcN1e7aHVZsI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00045