UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '3sp5qKBe8duC2MrOwUBKzowRtuboN0Q2db07eivNCiQ=' 
WHERE 
  key_id = '92c68b9a5756a90a32ee92073912b6d2abdc2ed15c0127248277ed6642982bea' 
  AND (
    token = '3sp5qKBe8duC2MrOwUBKzowRtuboN0Q2db07eivNCiQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00040