UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '+Z9m4VdB6Yeqn6j92iUo2CE1HTbMRZn2hAumSqRDsTo=' 
WHERE 
  key_id = '2a4fc0be4124e577e988c195fe27e51fadbfc7054a5ee549f1045733b46254fc' 
  AND (
    token = '+Z9m4VdB6Yeqn6j92iUo2CE1HTbMRZn2hAumSqRDsTo=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027