UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'f3oShcSTMgio2RczVBwgrGZRW25ZRW5vvI+VryCbNOo=' 
WHERE 
  key_id = '4835919dcffd0121342f5d80f0c8029badda30159620e1a6dd6d857c2231994b' 
  AND (
    token = 'f3oShcSTMgio2RczVBwgrGZRW25ZRW5vvI+VryCbNOo=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00052