UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'ihS/J8vGqEf8tkOf/iOMrIhJDg10E8Nave78xkOrBRo=' 
WHERE 
  key_id = '00e6b0544087a81c3a48de3dfe9d03117ec60b7ff101c99dd7bec67ede604fcd' 
  AND (
    token = 'ihS/J8vGqEf8tkOf/iOMrIhJDg10E8Nave78xkOrBRo=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00039