UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 's25VmJMe8a7mPfwYN8t289reo4HiV/bBfPQ3i4iH/IA=' 
WHERE 
  key_id = '4bbb15b6219d803c49bc474bc3775122766dc907e1c5623947e44a71c5f249be' 
  AND (
    token = 's25VmJMe8a7mPfwYN8t289reo4HiV/bBfPQ3i4iH/IA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00029